UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YZqu+jIGKx8b173Kx8DpCDk9bPrk7PkKbGWJXw3u9M4='
WHERE
key_id = '1497c3396815ea489a93b161551e60f68ab7e80dd83d4f4e0d36a71da54f0b42'
AND (
token = 'YZqu+jIGKx8b173Kx8DpCDk9bPrk7PkKbGWJXw3u9M4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)