UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wgv1sDfbIUbgn+6whWoislpy6wsL+BNhS/lAnN9xDC0='
WHERE
key_id = '39dc7c7e0d9b0682842893bfc98bb4d039a09a7007994e5eb2761e00b897c6a6'
AND (
token = 'Wgv1sDfbIUbgn+6whWoislpy6wsL+BNhS/lAnN9xDC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)