UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7/yHoAGCzy4/0uMoQeb8ekB6Z1y4cqbpg3kiNgAlnw='
WHERE
key_id = 'b70cef2da22d7b051b2c5b03a7d10c3fd7a0aa0cc4306d9a701285e06c4df339'
AND (
token = 'D7/yHoAGCzy4/0uMoQeb8ekB6Z1y4cqbpg3kiNgAlnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)