UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7nhx9ugjL8s3klk/n9fG5bkPnsak0RNtxu8r3qVNeMw='
WHERE
key_id = 'f3e2147f99a972d63bd906b38942d9abd6428ee696b57d7835a0f3c1b595048f'
AND (
token = '7nhx9ugjL8s3klk/n9fG5bkPnsak0RNtxu8r3qVNeMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)