UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9NKtE5QnKzdmzJBq2fVVMUPmy102rsI/gRFGDe95Awg='
WHERE
key_id = '985ee26567192b15e200acdfd5b9192fce64343a6e2687e627abefadc17f93a5'
AND (
token = '9NKtE5QnKzdmzJBq2fVVMUPmy102rsI/gRFGDe95Awg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)