UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+dHMUbIDO33l7trjnUYCfUGjeSY4SPUpfAC9murqUB4='
WHERE
key_id = '3e0308cbf0f7ed48a99e48fda4fbf441825f72020c518619177cb4fffb37d30a'
AND (
token = '+dHMUbIDO33l7trjnUYCfUGjeSY4SPUpfAC9murqUB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)