UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MDZpRl8KxGGTt+U1aGwPIhNgLHdO9M72iRuJ2HhtGks='
WHERE
key_id = 'cc18aa2f5970781ad7cf416a952e35f2e6029bdb53024ec919a72260f4a57cd9'
AND (
token = 'MDZpRl8KxGGTt+U1aGwPIhNgLHdO9M72iRuJ2HhtGks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)