UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GAaGAX8IFmuK9TkI1c5OXszQNWz0zi0CLjmhsfBO4Y='
WHERE
key_id = 'd711247254b1cb776a7308b55895d263373871dd4b3266f0756b898103244129'
AND (
token = '6GAaGAX8IFmuK9TkI1c5OXszQNWz0zi0CLjmhsfBO4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)