UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAY8DwJB+/0Z/8XTg4rxclAJZeS1x9Lweby+paC5iVs='
WHERE
key_id = 'defe17b3391a38a4f4f5bdd7af5f494f50bab98c28c652670890eee170a9d708'
AND (
token = 'HAY8DwJB+/0Z/8XTg4rxclAJZeS1x9Lweby+paC5iVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)