UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPKK1i9f/wQg5T4B9B9JZWd80qxKH16KdjuoxPnMlMw='
WHERE
key_id = 'bb2ea3d728b9e2d8c726e3fb09199ac5d7321c2da1f98f254ce0b58224c6a07f'
AND (
token = 'XPKK1i9f/wQg5T4B9B9JZWd80qxKH16KdjuoxPnMlMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)