UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1Z43JCsDRnaXB/QoOioa3JEynzSCmAM+nmTf4PXr3A='
WHERE
key_id = 'cfb8b36f17011d5fec13de98772800d0ece47716bb1fb1d5fd1e1ba524cdd11b'
AND (
token = 'c1Z43JCsDRnaXB/QoOioa3JEynzSCmAM+nmTf4PXr3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)