UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2QsbqEizn8n161RIlljrSF0gMaQ9hqzZW+aeer5NAIc='
WHERE
key_id = '002f4f8b93fbbcf90b4681476698045e66ac77824fe36cd73752a97e1ceb583a'
AND (
token = '2QsbqEizn8n161RIlljrSF0gMaQ9hqzZW+aeer5NAIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)