UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWMofn5QEEy42v3AwVsXmlgLjltf4CTWLIa5dxwlMJ0='
WHERE
key_id = '0e93381d6d00a7fd623ba90ce5450dd33e0319c2542a41d52ec5ea591157397b'
AND (
token = 'zWMofn5QEEy42v3AwVsXmlgLjltf4CTWLIa5dxwlMJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)