UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZaC4rXIr1+KeY+DPW3aDAm5sZkXJybWSeh0QSCPPnYw='
WHERE
key_id = 'f6cb8b9aa4b9477fe22341c61d45c04b080f8d34f78f05b0cfa9496b723fcf29'
AND (
token = 'ZaC4rXIr1+KeY+DPW3aDAm5sZkXJybWSeh0QSCPPnYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)