UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9fsMPDi6bcSoStaKvYsgZdKN4PSLqH7HfZmZXX/+k5w='
WHERE
key_id = 'e31df547ba741012625b132b121a5bb429c24536922ea6e085305e30eb65f05d'
AND (
token = '9fsMPDi6bcSoStaKvYsgZdKN4PSLqH7HfZmZXX/+k5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)