UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aWjSRqMHiFBlC8PKIIkC8I43przt9RG+kaG0sBr8/NI='
WHERE
key_id = 'e8ff66c7cde0838beb79269c198c7ac56f9e16d280b6bc887c380d368f6a026a'
AND (
token = 'aWjSRqMHiFBlC8PKIIkC8I43przt9RG+kaG0sBr8/NI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)