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