UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QFFx5poQboJxSeA/9mD/4X3VsSQeGpnPCVnfPR0UDpw='
WHERE
key_id = 'a1ab1718e8bd1a3fab3ec42c23ec82e2aea04031eecb2eb81844a18664d97ba3'
AND (
token = 'QFFx5poQboJxSeA/9mD/4X3VsSQeGpnPCVnfPR0UDpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)