UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iuNwJiV+odggC0GSgDZhJX3q7/f8+of2c4HKEFEaA+0='
WHERE
key_id = 'a821fefbe71c2415a658430c2e51022a081cfe0fa1944591059b90a187da7e3c'
AND (
token = 'iuNwJiV+odggC0GSgDZhJX3q7/f8+of2c4HKEFEaA+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)