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