UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yLiAwWqmAGzTg2FlWU57xgx5bUpigCgUeG9ZRVAMAMg='
WHERE
key_id = '96b1568d48fd6258b4c5932830691205041c14f15c44c43a7f2f4b85565e785d'
AND (
token = 'yLiAwWqmAGzTg2FlWU57xgx5bUpigCgUeG9ZRVAMAMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)