UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNa7YiElf5xYnGnYB1gL3cjDJcJovny1FII8s8RDmNI='
WHERE
key_id = 'fe64a0a3475e9d739003b7bff5bcaa7802c3b9d1671a3317a4d21710d6e3101c'
AND (
token = 'sNa7YiElf5xYnGnYB1gL3cjDJcJovny1FII8s8RDmNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)