UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8Mtv7VyucGVyHu7uCAdkXZl0UMrDKu2GznVRvwrLUQ='
WHERE
key_id = 'd426aabed60cb22ee44a5696df372e782bd99d1944cd12709e70559aaa8ae33a'
AND (
token = 'G8Mtv7VyucGVyHu7uCAdkXZl0UMrDKu2GznVRvwrLUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)