UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BU27MTB3/4FvS8+SHMOHfW9ISEkBlGYzdBJ+yoCITXI='
WHERE
key_id = '7bfacb5a8c3a71c6cd1dc050e873f7e8572949208f32425c7bce2c6fa6f78a11'
AND (
token = 'BU27MTB3/4FvS8+SHMOHfW9ISEkBlGYzdBJ+yoCITXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)