UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DyB/ZMHmpAVW+mK7xyH6Y8APhzIlQpkKwv1V7t33i2k='
WHERE
key_id = 'af817bd271cdb70f6402d2f64b8c4a4777548a7b0ef6b605996670d77a092705'
AND (
token = 'DyB/ZMHmpAVW+mK7xyH6Y8APhzIlQpkKwv1V7t33i2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)