UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I8kWeGQ6x81BB8D1MqBOo8pgTG8AOGqMTckA5wFtClU='
WHERE
key_id = '31d5a920554bfb436d94341d7c9a942bcc8f2fe52f16a37b0aaf284c915f90c7'
AND (
token = 'I8kWeGQ6x81BB8D1MqBOo8pgTG8AOGqMTckA5wFtClU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)