UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aRP1v+qt2HIYbYdbdvaxU/FxcJP1V0ymXHYgUGngqCg='
WHERE
key_id = 'a77adcd00524d8ae2987f557441202bc15560472d56e119f4fb81a4ec240f51b'
AND (
token = 'aRP1v+qt2HIYbYdbdvaxU/FxcJP1V0ymXHYgUGngqCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)