UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRsuM0HiWa3IVDZ2dAE8AJpnaEMdbmeDWTPlYpF7A40='
WHERE
key_id = 'bad4f8d4f131656a284537213f18cb734a28812db340b06cacc139fe9bca2250'
AND (
token = 'KRsuM0HiWa3IVDZ2dAE8AJpnaEMdbmeDWTPlYpF7A40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)