UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4TEsJAxjcNFnOp9kEvLLyesuprwwZym0qdd7+bJRwyI='
WHERE
key_id = '8e4f5d65c8aa7407ef429b795c08a0ab5cce0d982295b9399bd3d9705afdbc4b'
AND (
token = '4TEsJAxjcNFnOp9kEvLLyesuprwwZym0qdd7+bJRwyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)