UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'my+CvoyFpr3OvilKdffDQM7gh5hMrymgSnRHQbh7COE='
WHERE
key_id = 'd9be6839a3163b2dba97808ee01b4a2f3067989d9474514932c97e4c1584a2cb'
AND (
token = 'my+CvoyFpr3OvilKdffDQM7gh5hMrymgSnRHQbh7COE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)