UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0q2+Y4YZyY89rSsDtFXRpsLQk6NV8ngIFsYdrtdX3I='
WHERE
key_id = '540fbc96ec23de9c32658376317d4058425c69920fab76a36ae4983d16223eee'
AND (
token = 'U0q2+Y4YZyY89rSsDtFXRpsLQk6NV8ngIFsYdrtdX3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)