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