UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vQr+wgtzf8l6WxPXhL4IoXW+IPMB7py3nKIizvn8Jw='
WHERE
key_id = 'cdcd14bc330334833f8ac3c2514f11eb2d92f1137e75c061cb56d369389ce2ea'
AND (
token = '6vQr+wgtzf8l6WxPXhL4IoXW+IPMB7py3nKIizvn8Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)