UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HP5lImRVzk3ad3k4rFR03TAsBXkOWPdlSxvoV+GjxRA='
WHERE
key_id = '59212f89d081f94ac728b097d37c254b64cf4be06c72290ed21bc9cc95fe21ae'
AND (
token = 'HP5lImRVzk3ad3k4rFR03TAsBXkOWPdlSxvoV+GjxRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)