UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8DOaKga7K8hSzqrcaFzDvnpXbzNnmGLLLFBDVsE7Vfc='
WHERE
key_id = 'a317a2ff3dfef2afbb8e5306e93f9767da2b7c8f471e8978acc355f6b2ab252b'
AND (
token = '8DOaKga7K8hSzqrcaFzDvnpXbzNnmGLLLFBDVsE7Vfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)