UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/ViGF6wYLCvc4QBcllREm7clAmhTm3psPnMOcloako='
WHERE
key_id = '6e01b61d2448ecc18c0cc578d02b9a778b242a833d4f52eef305a5b2197c51a2'
AND (
token = 'P/ViGF6wYLCvc4QBcllREm7clAmhTm3psPnMOcloako='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)