UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd40uFp0IHQKaD6JS1YpGIlU3LaLPA6VSoSMzEEnZPvE='
WHERE
key_id = '065d7139d0033c809894cb6d75879b0578b648e0e645d591e2e975d1ace501fe'
AND (
token = 'd40uFp0IHQKaD6JS1YpGIlU3LaLPA6VSoSMzEEnZPvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)