UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1u5QeOaFgjb9+iFY4J4y1fo3RV1CiSSI7b1u00+mcq0='
WHERE
key_id = '3c707bf5b71ff08ce37743be3615f18a2f7cc68112e36f0fd69ae9499108e987'
AND (
token = '1u5QeOaFgjb9+iFY4J4y1fo3RV1CiSSI7b1u00+mcq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)