UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JWXbRNuLqdoBs7jECNeY6KbjWwvDTvweb320ZRf/t8='
WHERE
key_id = '493a4b2206497f51f240aed20665ad3d9ecc1e17d78468625942a3766f0c4136'
AND (
token = '4JWXbRNuLqdoBs7jECNeY6KbjWwvDTvweb320ZRf/t8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)