UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8VWV1zIJV7fYLJs7Z7eK7vG3r4YX5Sq4fVsIbnFOY0='
WHERE
key_id = 'ff3b3bd9357ed0ebf8ca66447e91382b2fd26efd4e68b69cc7b70026ec99d1c1'
AND (
token = 'B8VWV1zIJV7fYLJs7Z7eK7vG3r4YX5Sq4fVsIbnFOY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)