UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzifqn8vHahSZQM0qlqISyaYphX/cEgZmqbk36dsgVs='
WHERE
key_id = 'c3cd78d9799b842df674c8b3e5fe8bb0f12bd3c301b9027a5268995afa31e81b'
AND (
token = 'xzifqn8vHahSZQM0qlqISyaYphX/cEgZmqbk36dsgVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)