UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vdV5Nl2OadZ38kNfRgtpi1cRpL3eDSiFv2btKn3VAg8='
WHERE
key_id = 'ead49409d7111ab91b1b04d9eb652b99d936efd5e8b03b7e0a7a9ce4ad1b065e'
AND (
token = 'vdV5Nl2OadZ38kNfRgtpi1cRpL3eDSiFv2btKn3VAg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)