UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRHcVHEKlCpYqogW+/h+NgupPHUCCQQsN+ILAUNUKhs='
WHERE
key_id = '2948f5bd781ed03911700bec42f3ee736a0f265d10919095866e4addabb96aac'
AND (
token = 'pRHcVHEKlCpYqogW+/h+NgupPHUCCQQsN+ILAUNUKhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)