UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/N+4jMZdBdd0nhqa9BdUgRoZGOZKaOtAdCyjD9gMP2M='
WHERE
key_id = '7f5f3379aae989fc2001cc7907f33154b8df9410be17a360a389082a02b76d9f'
AND (
token = '/N+4jMZdBdd0nhqa9BdUgRoZGOZKaOtAdCyjD9gMP2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)