UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gR7pCZgE5Kq0rLhi4m6xmQJDqPCtEZb7peLedFLCUI='
WHERE
key_id = 'e2e84a2e0f8ca75651fd7bd183338ee35b71f00525b3c9db1d1ce61b7cf03428'
AND (
token = '4gR7pCZgE5Kq0rLhi4m6xmQJDqPCtEZb7peLedFLCUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)