UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmc+Tp0qxYy4GvnMxQGyS5bwF4z/K1beosChnnCwNAE='
WHERE
key_id = '9f49842497c94d5ed6daaed6bd8d09a9a397c3f72b3c8d4fd7bfbb16ed845aec'
AND (
token = 'tmc+Tp0qxYy4GvnMxQGyS5bwF4z/K1beosChnnCwNAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)